Release 10.1A: OpenEdge Development:
Java Open Clients

Choosing JDBC ResultSets or SDOResultSets to access Progress data

Progress Software Corporation supports a JDBC interface directly to the OpenEdge database. Some applications might benefit from using the direct JDBC interface to OpenEdge rather than SDOResultSets, and others might benefit more from using SDOResultSets.

JDBC access to the OpenEdge database should be used in the following cases:

There is no 4GL business logic (such as 4GL triggers) that must be used.
Two-tier access (client/server) is sufficient.
The client side application requires full JDBC support.

SmartDataObject ResultSets should be used in the following cases:

4GL business logic is part of the AppServer application.
N-tier configuration is required for performance or other reasons.
Higher than JDBC 1 level of access is required. SDOResultSet, which is based on JDBC 2, is easier to use and does not require knowledge of SQL.